Release 10.1A: OpenEdge Data Management:
Database Administration
PROUTIL DUMPSPECIFIED qualifier
Performs a binary dump of selected records.
Syntax
Parameters
db-nameSpecifies the database where the dump will occur. You must completely define the path.
owner-nameSpecifies the owner of the table containing the data you want to dump. You must specify an owner name unless the table’s name is unique within the database, or the table is owned by PUB. By default, Progress 4GL tables are owned by PUB.
table-nameSpecifies the name of the table containing the data you want to dump.
field-nameSpecifies the name of the index field to be used to select the data you want to dump.
operatorSpecifies the operator to be used:
EQ(equals to),GT(greater than),LT(less than),GE(greater than or equal to), orLE(less than or equal to).field-valueSpecifies the value against which the
field-namevalue will be compared.directorySpecifies the name of the target directory where the data will be dumped. A directory must be specified.
Notes
- If a field needs to be compared to a string containing other than alpha characters (including spaces or numbers), single quote the string. For example:
‘John Smith’,‘11-14-2001’, or‘25 Main St’.- Dumping the data using a character comparison is case-sensitive.
- If specifying a monetary value, do not include the money unit. For example, instead of $5.50, enter
5.5.- If specifying a negative number, escape the minus sign with a backslash (\). For example:
proutil testdb -C dumpspecified “PUB.Item.Item-NUM” LT “\-90”.- Dates must be entered as mm-dd-yyyy.
- The value entered for
field-namemust be the name of an index field.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |